using HKB.Common;
using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.ComponentModel.Design;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Diagnostics;
namespace HKB.Data.Dal.H_UserInfoTableAdapters
{
	[GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0"), DataObject(true), HelpKeyword("vs.data.TableAdapter"), Designer("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), DesignerCategory("code"), ToolboxItem(true)]
	public class HL_UserInfoTableAdapter : Component
	{
		private SqlDataAdapter _adapter;
		private SqlConnection _connection;
		private SqlCommand[] _commandCollection;
		private bool _clearBeforeFill;
		[System.Diagnostics.DebuggerNonUserCode]
		private SqlDataAdapter Adapter
		{
			get
			{
				if (this._adapter == null)
				{
					this.InitAdapter();
				}
				return this._adapter;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		internal SqlConnection Connection
		{
			get
			{
				if (this._connection == null)
				{
					this.InitConnection();
				}
				return this._connection;
			}
			set
			{
				this._connection = value;
				if (this.Adapter.InsertCommand != null)
				{
					this.Adapter.InsertCommand.Connection = value;
				}
				if (this.Adapter.DeleteCommand != null)
				{
					this.Adapter.DeleteCommand.Connection = value;
				}
				if (this.Adapter.UpdateCommand != null)
				{
					this.Adapter.UpdateCommand.Connection = value;
				}
				for (int i = 0; i < this.CommandCollection.Length; i++)
				{
					if (this.CommandCollection[i] != null)
					{
						this.CommandCollection[i].Connection = value;
					}
				}
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		protected SqlCommand[] CommandCollection
		{
			get
			{
				if (this._commandCollection == null)
				{
					this.InitCommandCollection();
				}
				return this._commandCollection;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public bool ClearBeforeFill
		{
			get
			{
				return this._clearBeforeFill;
			}
			set
			{
				this._clearBeforeFill = value;
			}
		}
		[System.Diagnostics.DebuggerNonUserCode]
		public HL_UserInfoTableAdapter()
		{
			this.ClearBeforeFill = true;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitAdapter()
		{
			this._adapter = new SqlDataAdapter();
			DataTableMapping dataTableMapping = new DataTableMapping();
			dataTableMapping.SourceTable = "Table";
			dataTableMapping.DataSetTable = "HL_UserInfo";
			dataTableMapping.ColumnMappings.Add("UserInfoID", "UserInfoID");
			dataTableMapping.ColumnMappings.Add("UserID", "UserID");
			dataTableMapping.ColumnMappings.Add("Country", "Country");
			dataTableMapping.ColumnMappings.Add("Province", "Province");
			dataTableMapping.ColumnMappings.Add("City", "City");
			dataTableMapping.ColumnMappings.Add("ZipCode", "ZipCode");
			dataTableMapping.ColumnMappings.Add("Address", "Address");
			dataTableMapping.ColumnMappings.Add("ComeFrom", "ComeFrom");
			dataTableMapping.ColumnMappings.Add("Nation", "Nation");
			dataTableMapping.ColumnMappings.Add("Birthday", "Birthday");
			dataTableMapping.ColumnMappings.Add("TrueName", "TrueName");
			dataTableMapping.ColumnMappings.Add("IDCard", "IDCard");
			dataTableMapping.ColumnMappings.Add("Marriage", "Marriage");
			dataTableMapping.ColumnMappings.Add("Family", "Family");
			dataTableMapping.ColumnMappings.Add("InCome", "InCome");
			dataTableMapping.ColumnMappings.Add("Eductation", "Eductation");
			dataTableMapping.ColumnMappings.Add("GraduteSchool", "GraduteSchool");
			dataTableMapping.ColumnMappings.Add("Interests", "Interests");
			dataTableMapping.ColumnMappings.Add("CreateTime", "CreateTime");
			dataTableMapping.ColumnMappings.Add("UpdateTime", "UpdateTime");
			dataTableMapping.ColumnMappings.Add("Owner", "Owner");
			dataTableMapping.ColumnMappings.Add("ICQ", "ICQ");
			dataTableMapping.ColumnMappings.Add("OICQ", "OICQ");
			dataTableMapping.ColumnMappings.Add("MSN", "MSN");
			dataTableMapping.ColumnMappings.Add("HomePage", "HomePage");
			dataTableMapping.ColumnMappings.Add("HomePhone", "HomePhone");
			dataTableMapping.ColumnMappings.Add("Fax", "Fax");
			dataTableMapping.ColumnMappings.Add("Taobaowangwang", "Taobaowangwang");
			dataTableMapping.ColumnMappings.Add("sex", "sex");
			dataTableMapping.ColumnMappings.Add("NickName", "NickName");
			dataTableMapping.ColumnMappings.Add("ShopID", "ShopID");
			dataTableMapping.ColumnMappings.Add("ContactTime", "ContactTime");
			dataTableMapping.ColumnMappings.Add("ContactType", "ContactType");
			dataTableMapping.ColumnMappings.Add("IDCardPhotoUrl", "IDCardPhotoUrl");
			dataTableMapping.ColumnMappings.Add("SaleCrediet", "SaleCrediet");
			dataTableMapping.ColumnMappings.Add("BuyCrediet", "BuyCrediet");
			dataTableMapping.ColumnMappings.Add("MobilePhone", "MobilePhone");
			dataTableMapping.ColumnMappings.Add("IDCardPhoto", "IDCardPhoto");
			dataTableMapping.ColumnMappings.Add("UserType", "UserType");
			dataTableMapping.ColumnMappings.Add("CompanyName", "CompanyName");
			dataTableMapping.ColumnMappings.Add("intro", "intro");
			dataTableMapping.ColumnMappings.Add("AuthenticationType", "AuthenticationType");
			dataTableMapping.ColumnMappings.Add("CompanyIdentify", "CompanyIdentify");
			dataTableMapping.ColumnMappings.Add("MobileIdentify", "MobileIdentify");
			dataTableMapping.ColumnMappings.Add("BandShopIdentify", "BandShopIdentify");
			dataTableMapping.ColumnMappings.Add("OtherIdentify1", "OtherIdentify1");
			dataTableMapping.ColumnMappings.Add("OtherIdentify2", "OtherIdentify2");
			dataTableMapping.ColumnMappings.Add("OtherIdentify3", "OtherIdentify3");
			dataTableMapping.ColumnMappings.Add("OtherIdentify4", "OtherIdentify4");
			dataTableMapping.ColumnMappings.Add("ApplicationID", "ApplicationID");
			this._adapter.TableMappings.Add(dataTableMapping);
			this._adapter.DeleteCommand = new SqlCommand();
			this._adapter.DeleteCommand.Connection = this.Connection;
			this._adapter.DeleteCommand.CommandText = "DELETE FROM [HL_UserInfo] WHERE (([UserInfoID] = @Original_UserInfoID))";
			this._adapter.DeleteCommand.CommandType = CommandType.Text;
			this._adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Original_UserInfoID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserInfoID", DataRowVersion.Original, false, null, "", "", ""));
			this._adapter.InsertCommand = new SqlCommand();
			this._adapter.InsertCommand.Connection = this.Connection;
			this._adapter.InsertCommand.CommandText = "INSERT INTO [HL_UserInfo] ([UserID], [Country], [Province], [City], [ZipCode], [Address], [ComeFrom], [Nation], [Birthday], [TrueName], [IDCard], [Marriage], [Family], [InCome], [Eductation], [GraduteSchool], [Interests], [CreateTime], [UpdateTime], [Owner], [ICQ], [OICQ], [MSN], [HomePage], [HomePhone], [MobilePhone], [Fax], [Taobaowangwang], [sex], [NickName], [ShopID], [ContactTime], [ContactType], [IDCardPhoto], [SaleCrediet], [BuyCrediet], [UserType], [CompanyName], [intro], [AuthenticationType], [CompanyIdentify], [MobileIdentify], [BandShopIdentify], [OtherIdentify1], [OtherIdentify2], [OtherIdentify3], [OtherIdentify4], [ApplicationID]) VALUES (@UserID, @Country, @Province, @City, @ZipCode, @Address, @ComeFrom, @Nation, @Birthday, @TrueName, @IDCard, @Marriage, @Family, @InCome, @Eductation, @GraduteSchool, @Interests, @CreateTime, @UpdateTime, @Owner, @ICQ, @OICQ, @MSN, @HomePage, @HomePhone, @MobilePhone, @Fax, @Taobaowangwang, @sex, @NickName, @ShopID, @ContactTime, @ContactType, @IDCardPhoto, @SaleCrediet, @BuyCrediet, @UserType, @CompanyName, @intro, @AuthenticationType, @CompanyIdentify, @MobileIdentify, @BandShopIdentify, @OtherIdentify1, @OtherIdentify2, @OtherIdentify3, @OtherIdentify4, @ApplicationID)";
			this._adapter.InsertCommand.CommandType = CommandType.Text;
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Country", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Country", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Province", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Province", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "City", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ZipCode", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ZipCode", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Address", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ComeFrom", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ComeFrom", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Nation", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Nation", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Birthday", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "Birthday", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@TrueName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "TrueName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IDCard", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "IDCard", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Marriage", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Marriage", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Family", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Family", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@InCome", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "InCome", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Eductation", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Eductation", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@GraduteSchool", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "GraduteSchool", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Interests", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Interests", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CreateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "CreateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Owner", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Owner", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ICQ", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ICQ", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OICQ", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "OICQ", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MSN", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "MSN", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@HomePage", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "HomePage", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@HomePhone", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "HomePhone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "MobilePhone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Fax", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Fax", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@Taobaowangwang", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Taobaowangwang", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@sex", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "sex", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "NickName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ContactTime", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ContactTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ContactType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ContactType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@IDCardPhoto", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "IDCardPhoto", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@SaleCrediet", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SaleCrediet", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BuyCrediet", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BuyCrediet", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@UserType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CompanyName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "CompanyName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@intro", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "intro", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@AuthenticationType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "AuthenticationType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@CompanyIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CompanyIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@MobileIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "MobileIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@BandShopIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BandShopIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OtherIdentify1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OtherIdentify2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OtherIdentify3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@OtherIdentify4", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.InsertCommand.Parameters.Add(new SqlParameter("@ApplicationID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ApplicationID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand = new SqlCommand();
			this._adapter.UpdateCommand.Connection = this.Connection;
			this._adapter.UpdateCommand.CommandText = "UPDATE [HL_UserInfo] SET [UserID] = @UserID, [Country] = @Country, [Province] = @Province, [City] = @City, [ZipCode] = @ZipCode, [Address] = @Address, [ComeFrom] = @ComeFrom, [Nation] = @Nation, [Birthday] = @Birthday, [TrueName] = @TrueName, [IDCard] = @IDCard, [Marriage] = @Marriage, [Family] = @Family, [InCome] = @InCome, [Eductation] = @Eductation, [GraduteSchool] = @GraduteSchool, [Interests] = @Interests, [CreateTime] = @CreateTime, [UpdateTime] = @UpdateTime, [Owner] = @Owner, [ICQ] = @ICQ, [OICQ] = @OICQ, [MSN] = @MSN, [HomePage] = @HomePage, [HomePhone] = @HomePhone, [MobilePhone] = @MobilePhone, [Fax] = @Fax, [Taobaowangwang] = @Taobaowangwang, [sex] = @sex, [NickName] = @NickName, [ShopID] = @ShopID, [ContactTime] = @ContactTime, [ContactType] = @ContactType, [IDCardPhoto] = @IDCardPhoto, [SaleCrediet] = @SaleCrediet, [BuyCrediet] = @BuyCrediet, [UserType] = @UserType, [CompanyName] = @CompanyName, [intro] = @intro, [AuthenticationType] = @AuthenticationType, [CompanyIdentify] = @CompanyIdentify, [MobileIdentify] = @MobileIdentify, [BandShopIdentify] = @BandShopIdentify, [OtherIdentify1] = @OtherIdentify1, [OtherIdentify2] = @OtherIdentify2, [OtherIdentify3] = @OtherIdentify3, [OtherIdentify4] = @OtherIdentify4, [ApplicationID] = @ApplicationID WHERE (([UserInfoID] = @Original_UserInfoID))";
			this._adapter.UpdateCommand.CommandType = CommandType.Text;
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Country", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Country", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Province", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Province", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "City", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ZipCode", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ZipCode", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Address", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ComeFrom", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ComeFrom", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Nation", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Nation", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Birthday", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "Birthday", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@TrueName", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "TrueName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IDCard", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "IDCard", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Marriage", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "Marriage", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Family", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Family", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@InCome", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "InCome", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Eductation", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Eductation", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@GraduteSchool", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "GraduteSchool", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Interests", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "Interests", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CreateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "CreateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UpdateTime", SqlDbType.DateTime, 0, ParameterDirection.Input, 0, 0, "UpdateTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Owner", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "Owner", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ICQ", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "ICQ", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OICQ", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "OICQ", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MSN", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "MSN", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@HomePage", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "HomePage", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@HomePhone", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "HomePhone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "MobilePhone", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Fax", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Fax", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Taobaowangwang", SqlDbType.NVarChar, 0, ParameterDirection.Input, 0, 0, "Taobaowangwang", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@sex", SqlDbType.Bit, 0, ParameterDirection.Input, 0, 0, "sex", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "NickName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ContactTime", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ContactTime", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ContactType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ContactType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@IDCardPhoto", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "IDCardPhoto", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@SaleCrediet", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "SaleCrediet", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BuyCrediet", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BuyCrediet", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@UserType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CompanyName", SqlDbType.VarChar, 0, ParameterDirection.Input, 0, 0, "CompanyName", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@intro", SqlDbType.Text, 0, ParameterDirection.Input, 0, 0, "intro", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@AuthenticationType", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "AuthenticationType", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@CompanyIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "CompanyIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@MobileIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "MobileIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@BandShopIdentify", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "BandShopIdentify", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OtherIdentify1", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify1", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OtherIdentify2", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify2", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OtherIdentify3", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify3", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@OtherIdentify4", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "OtherIdentify4", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@ApplicationID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "ApplicationID", DataRowVersion.Current, false, null, "", "", ""));
			this._adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Original_UserInfoID", SqlDbType.Int, 0, ParameterDirection.Input, 0, 0, "UserInfoID", DataRowVersion.Original, false, null, "", "", ""));
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitConnection()
		{
			this._connection = new SqlConnection();
			this._connection.ConnectionString = Conn.CurrenConnectionStrings;
		}
		[System.Diagnostics.DebuggerNonUserCode]
		private void InitCommandCollection()
		{
			this._commandCollection = new SqlCommand[17];
			this._commandCollection[0] = new SqlCommand();
			this._commandCollection[0].Connection = this.Connection;
			this._commandCollection[0].CommandText = "SELECT UserInfoID, UserID, Country, Province, City, ZipCode, Address, ComeFrom, Nation, \r\n      Birthday, TrueName, IDCard, Marriage, Family, InCome, Eductation, GraduteSchool, \r\n      Interests, CreateTime, UpdateTime, Owner, ICQ, OICQ, MSN, HomePage, HomePhone, \r\n      MobilePhone, Fax, Taobaowangwang, sex, NickName, ShopID, ContactTime, \r\n      ContactType, IDCardPhoto, SaleCrediet, BuyCrediet, UserType, CompanyName, intro, \r\n      AuthenticationType, CompanyIdentify, MobileIdentify, BandShopIdentify, \r\n      OtherIdentify1, OtherIdentify2, OtherIdentify3, OtherIdentify4, ApplicationID\r\nFROM HL_UserInfo";
			this._commandCollection[0].CommandType = CommandType.Text;
			this._commandCollection[1] = new SqlCommand();
			this._commandCollection[1].Connection = this.Connection;
			this._commandCollection[1].CommandText = "UPDATE HL_UserInfo\r\nSET AuthenticationType= @AuthenticationType\r\nWHERE (UserID = @UserID)";
			this._commandCollection[1].CommandType = CommandType.Text;
			this._commandCollection[1].Parameters.Add(new SqlParameter("@AuthenticationType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "AuthenticationType", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[1].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Original, false, null, "", "", ""));
			this._commandCollection[2] = new SqlCommand();
			this._commandCollection[2].Connection = this.Connection;
			this._commandCollection[2].CommandText = "SELECT  HL_UserInfo.*,\r\nHL_User.UserName From HL_UserInfo inner Join HL_User On\r\nHL_User.UserID=HL_UserInfo.UserID";
			this._commandCollection[2].CommandType = CommandType.Text;
			this._commandCollection[3] = new SqlCommand();
			this._commandCollection[3].Connection = this.Connection;
			this._commandCollection[3].CommandText = "SELECT HL_UserInfo.UserInfoID,HL_UserInfo.UserID,HL_UserInfo.OICQ, HL_UserInfo.Taobaowangwang,HL_User.UserName FROM HL_UserInfo inner Join HL_User ON HL_User.UserID=HL_UserInfo.UserID WHERE (HL_UserInfo.UserID = @UserID)";
			this._commandCollection[3].CommandType = CommandType.Text;
			this._commandCollection[3].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4] = new SqlCommand();
			this._commandCollection[4].Connection = this.Connection;
			this._commandCollection[4].CommandText = "Pr_GetShopUploadShopFile";
			this._commandCollection[4].CommandType = CommandType.StoredProcedure;
			this._commandCollection[4].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@UploadFileName", SqlDbType.VarChar, 100, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[4].Parameters.Add(new SqlParameter("@U_Identify", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[5] = new SqlCommand();
			this._commandCollection[5].Connection = this.Connection;
			this._commandCollection[5].CommandText = "SELECT HL_UserInfo.SaleCrediet, HL_UserInfo.BuyCrediet, HL_User.UserName, \r\n      HL_User.LastLoginTime, HL_User.RegTime, HL_UserInfo.UserID, \r\n      HL_UserInfo.Taobaowangwang, HL_UserInfo.OICQ, HL_UserInfo.Province, \r\n      HL_UserInfo.City, HL_UserInfo.Address, HL_UserInfo.AuthenticationType, \r\n      HL_User.ShopID, HL_UserInfo.UserInfoID, HL_UserInfo.MobileIdentify, \r\n      HL_UserInfo.CompanyIdentify, HL_UserInfo.BandShopIdentify, \r\n      HL_UserInfo.OtherIdentify1, HL_UserInfo.OtherIdentify2, HL_UserInfo.OtherIdentify3, \r\n      HL_UserInfo.OtherIdentify4\r\nFROM HL_UserInfo INNER JOIN\r\n      HL_User ON HL_UserInfo.UserID = HL_User.UserID\r\nWHERE (HL_UserInfo.UserID = @UserID)";
			this._commandCollection[5].CommandType = CommandType.Text;
			this._commandCollection[5].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6] = new SqlCommand();
			this._commandCollection[6].Connection = this.Connection;
			this._commandCollection[6].CommandText = "pr_GetShopByuserid";
			this._commandCollection[6].CommandType = CommandType.StoredProcedure;
			this._commandCollection[6].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[6].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[7] = new SqlCommand();
			this._commandCollection[7].Connection = this.Connection;
			this._commandCollection[7].CommandText = "SELECT HL_UserInfo.UserInfoID, HL_UserInfo.UserID,\r\n      HL_UserInfo.AuthenticationType, HL_UserInfo.CompanyIdentify,HL_UserInfo.MobileIdentify,                      HL_UserInfo.BandShopIdentify,HL_UserInfo.OtherIdentify1,\r\nHL_UserInfo.OtherIdentify2,HL_UserInfo.OtherIdentify3,\r\nHL_UserInfo.OtherIdentify4,HL_User.UserName\r\nFROM HL_UserInfo INNER JOIN\r\n      HL_User ON HL_UserInfo.UserID = HL_User.UserID\r\nWHERE (HL_UserInfo.UserID = @UserID)";
			this._commandCollection[7].CommandType = CommandType.Text;
			this._commandCollection[7].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[8] = new SqlCommand();
			this._commandCollection[8].Connection = this.Connection;
			this._commandCollection[8].CommandText = "SELECT Address, ApplicationID, AuthenticationType, BandShopIdentify, Birthday, BuyCrediet, City, ComeFrom, CompanyIdentify, CompanyName, ContactTime, ContactType, Country, CreateTime, Eductation, Family, Fax, GraduteSchool, HomePage, HomePhone, ICQ, IDCard, IDCardPhoto, InCome, Interests, MSN, Marriage, MobileIdentify, MobilePhone, Nation, NickName, OICQ, OtherIdentify1, OtherIdentify2, OtherIdentify3, OtherIdentify4, Owner, Province, SaleCrediet, ShopID, Taobaowangwang, TrueName, UpdateTime, UserID, UserInfoID, UserType, ZipCode, intro, sex FROM HL_UserInfo WHERE (UserInfoID = @UserInfoID)";
			this._commandCollection[8].CommandType = CommandType.Text;
			this._commandCollection[8].Parameters.Add(new SqlParameter("@UserInfoID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserInfoID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9] = new SqlCommand();
			this._commandCollection[9].Connection = this.Connection;
			this._commandCollection[9].CommandText = "PR_GetUserInfoByNickNameIdentify";
			this._commandCollection[9].CommandType = CommandType.StoredProcedure;
			this._commandCollection[9].Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int, 4, ParameterDirection.ReturnValue, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[9].Parameters.Add(new SqlParameter("@Identify", SqlDbType.Int, 4, ParameterDirection.Input, 10, 0, null, DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[10] = new SqlCommand();
			this._commandCollection[10].Connection = this.Connection;
			this._commandCollection[10].CommandText = "SELECT Address, ApplicationID, AuthenticationType, BandShopIdentify, Birthday, BuyCrediet, City, ComeFrom, CompanyIdentify, CompanyName, ContactTime, ContactType, Country, CreateTime, Eductation, Family, Fax, GraduteSchool, HomePage, HomePhone, ICQ, IDCard, IDCardPhoto, InCome, Interests, MSN, Marriage, MobileIdentify, MobilePhone, Nation, NickName, OICQ, OtherIdentify1, OtherIdentify2, OtherIdentify3, OtherIdentify4, Owner, Province, SaleCrediet, ShopID, Taobaowangwang, TrueName, UpdateTime, UserID, UserInfoID, UserType, ZipCode, intro, sex FROM HL_UserInfo WHERE (ShopID = @ShopID)";
			this._commandCollection[10].CommandType = CommandType.Text;
			this._commandCollection[10].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[11] = new SqlCommand();
			this._commandCollection[11].Connection = this.Connection;
			this._commandCollection[11].CommandText = "SELECT HL_UserInfo.UserInfoID, HL_UserInfo.UserID, HL_UserInfo.Country, \r\n      HL_UserInfo.Province, HL_UserInfo.City, HL_UserInfo.ZipCode, HL_UserInfo.Address, \r\n      HL_UserInfo.ComeFrom, HL_UserInfo.Nation, HL_UserInfo.Birthday, \r\n      HL_UserInfo.TrueName, HL_UserInfo.IDCard, HL_UserInfo.Marriage, \r\n      HL_UserInfo.Family, HL_UserInfo.InCome, HL_UserInfo.Eductation, \r\n      HL_UserInfo.GraduteSchool, HL_UserInfo.Interests, HL_UserInfo.CreateTime, \r\n      HL_UserInfo.UpdateTime, HL_UserInfo.Owner, HL_UserInfo.ICQ, HL_UserInfo.OICQ, \r\n      HL_UserInfo.MSN, HL_UserInfo.HomePage, HL_UserInfo.HomePhone, \r\n      HL_UserInfo.MobilePhone, HL_UserInfo.Fax, HL_UserInfo.Taobaowangwang, \r\n      HL_UserInfo.sex, HL_UserInfo.NickName, HL_UserInfo.ShopID, \r\n      HL_UserInfo.ContactTime, HL_UserInfo.ContactType, \r\n      HL_UserInfo.IDCardPhoto, HL_UserInfo.SaleCrediet, HL_UserInfo.BuyCrediet, \r\n      HL_UserInfo.AuthenticationType,HL_User.Email\r\nFROM HL_UserInfo INNER JOIN\r\n      HL_User ON HL_UserInfo.UserID = HL_User.UserID\r\nWHERE (Email = @Email)";
			this._commandCollection[11].CommandType = CommandType.Text;
			this._commandCollection[11].Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar, 50, ParameterDirection.Input, 0, 0, "Email", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[12] = new SqlCommand();
			this._commandCollection[12].Connection = this.Connection;
			this._commandCollection[12].CommandText = "SELECT Address, ApplicationID, AuthenticationType, BandShopIdentify, Birthday, BuyCrediet, City, ComeFrom, CompanyIdentify, CompanyName, ContactTime, ContactType, Country, CreateTime, Eductation, Family, Fax, GraduteSchool, HomePage, HomePhone, ICQ, IDCard, IDCardPhoto, InCome, Interests, MSN, Marriage, MobileIdentify, MobilePhone, Nation, NickName, OICQ, OtherIdentify1, OtherIdentify2, OtherIdentify3, OtherIdentify4, Owner, Province, SaleCrediet, ShopID, Taobaowangwang, TrueName, UpdateTime, UserID, UserInfoID, UserType, ZipCode, intro, sex FROM HL_UserInfo WHERE (NickName = @NickName)";
			this._commandCollection[12].CommandType = CommandType.Text;
			this._commandCollection[12].Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "NickName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[13] = new SqlCommand();
			this._commandCollection[13].Connection = this.Connection;
			this._commandCollection[13].CommandText = "SELECT Address, ApplicationID, AuthenticationType, BandShopIdentify, Birthday, BuyCrediet, City, ComeFrom, CompanyIdentify, CompanyName, ContactTime, ContactType, Country, CreateTime, Eductation, Family, Fax, GraduteSchool, HomePage, HomePhone, ICQ, IDCard, IDCardPhoto, InCome, Interests, MSN, Marriage, MobileIdentify, MobilePhone, Nation, NickName, OICQ, OtherIdentify1, OtherIdentify2, OtherIdentify3, OtherIdentify4, Owner, Province, SaleCrediet, ShopID, Taobaowangwang, TrueName, UpdateTime, UserID, UserInfoID, UserType, ZipCode, intro, sex FROM HL_UserInfo WHERE (NickName = @NickName)";
			this._commandCollection[13].CommandType = CommandType.Text;
			this._commandCollection[13].Parameters.Add(new SqlParameter("@NickName", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "NickName", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[14] = new SqlCommand();
			this._commandCollection[14].Connection = this.Connection;
			this._commandCollection[14].CommandText = "\r\n                      SELECT HL_UserInfo.Address, HL_UserInfo.AuthenticationType, HL_UserInfo.Birthday,\r\n                      HL_UserInfo.BuyCrediet, HL_UserInfo.City, HL_UserInfo.ComeFrom,\r\n                      HL_UserInfo.CompanyName, HL_UserInfo.ContactTime, HL_UserInfo.ContactType,\r\n                      HL_UserInfo.Country, HL_UserInfo.CreateTime, HL_UserInfo.Eductation,\r\n                      HL_UserInfo.Family, HL_UserInfo.Fax, HL_UserInfo.GraduteSchool,\r\n                      HL_UserInfo.HomePage, HL_UserInfo.HomePhone, HL_UserInfo.ICQ,\r\n                      HL_UserInfo.IDCard, HL_UserInfo.IDCardPhoto, HL_UserInfo.InCome,HL_UserInfo.Interests,\r\n                      HL_UserInfo.MSN,\r\n                      case  when  HL_UserInfo.Marriage IS    NULL then 0 else HL_UserInfo.Marriage end as Marriage\r\n                      , HL_UserInfo.MobilePhone,\r\n                      HL_UserInfo.Nation, HL_UserInfo.NickName, HL_UserInfo.OICQ, HL_UserInfo.Owner,\r\n                      HL_UserInfo.Province, HL_UserInfo.SaleCrediet, HL_UserInfo.CompanyIdentify,HL_UserInfo.MobileIdentify,\r\n                      HL_UserInfo.BandShopIdentify,HL_UserInfo.OtherIdentify1,HL_UserInfo.OtherIdentify2,HL_UserInfo.OtherIdentify3,HL_UserInfo.OtherIdentify4,\r\n                      HL_UserInfo.ShopID, HL_UserInfo.Taobaowangwang, HL_UserInfo.TrueName,\r\n                      HL_UserInfo.UpdateTime, HL_UserInfo.UserID,\r\n                      HL_UserInfo.UserInfoID, HL_UserInfo.UserType, HL_UserInfo.ZipCode,\r\n                      HL_UserInfo.intro, HL_User.UserName, HL_User.Email,\r\n                      HL_User.Sex,HL_User.LastLoginTime\r\n                      FROM HL_UserInfo INNER JOIN\r\n                      HL_User ON HL_UserInfo.UserID = HL_User.UserID\r\n                      WHERE (HL_UserInfo.UserID = @UserID)";
			this._commandCollection[14].CommandType = CommandType.Text;
			this._commandCollection[14].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[15] = new SqlCommand();
			this._commandCollection[15].Connection = this.Connection;
			this._commandCollection[15].CommandText = "SELECT Address, ApplicationID, AuthenticationType, BandShopIdentify, Birthday, BuyCrediet, City, ComeFrom, CompanyIdentify, CompanyName, ContactTime, ContactType, Country, CreateTime, Eductation, Family, Fax, GraduteSchool, HomePage, HomePhone, ICQ, IDCard, IDCardPhoto, InCome, Interests, MSN, Marriage, MobileIdentify, MobilePhone, Nation, NickName, OICQ, OtherIdentify1, OtherIdentify2, OtherIdentify3, OtherIdentify4, Owner, Province, SaleCrediet, ShopID, Taobaowangwang, TrueName, UpdateTime, UserID, UserInfoID, UserType, ZipCode, intro, sex FROM HL_UserInfo WHERE (UserID = @UserID)";
			this._commandCollection[15].CommandType = CommandType.Text;
			this._commandCollection[15].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16] = new SqlCommand();
			this._commandCollection[16].Connection = this.Connection;
			this._commandCollection[16].CommandText = "INSERT INTO HL_UserInfo\r\n      (UserID, ShopID, AuthenticationType)\r\nVALUES (@UserID,@ShopID,@AnthenticationType)";
			this._commandCollection[16].CommandType = CommandType.Text;
			this._commandCollection[16].Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "UserID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@ShopID", SqlDbType.Int, 4, ParameterDirection.Input, 0, 0, "ShopID", DataRowVersion.Current, false, null, "", "", ""));
			this._commandCollection[16].Parameters.Add(new SqlParameter("@AnthenticationType", SqlDbType.VarChar, 50, ParameterDirection.Input, 0, 0, "AuthenticationType", DataRowVersion.Current, false, null, "", "", ""));
		}
		[DataObjectMethod(DataObjectMethodType.Select, true), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetAllUserInfo()
		{
			this.Adapter.SelectCommand = this.CommandCollection[0];
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetAllIdentifyUser()
		{
			this.Adapter.SelectCommand = this.CommandCollection[2];
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetQQTaobaoUserNameByUserID(int UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[3];
			this.Adapter.SelectCommand.Parameters[0].Value = UserID;
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetShopUploadUserInfoFile(string NickName, string UploadFileName, int? U_Identify)
		{
			this.Adapter.SelectCommand = this.CommandCollection[4];
			if (NickName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = NickName;
			}
			if (UploadFileName == null)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = UploadFileName;
			}
			if (U_Identify.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[3].Value = U_Identify.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[3].Value = System.DBNull.Value;
			}
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetShopUserBaseInfoByUserID(int UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[5];
			this.Adapter.SelectCommand.Parameters[0].Value = UserID;
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserByUserID(int? UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[6];
			if (UserID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = UserID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserIdentifyByUserID(int UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[7];
			this.Adapter.SelectCommand.Parameters[0].Value = UserID;
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserInfoByID(int UserInfoID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[8];
			this.Adapter.SelectCommand.Parameters[0].Value = UserInfoID;
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserInfoByNickNameIdentify(string NickName, int? Identify)
		{
			this.Adapter.SelectCommand = this.CommandCollection[9];
			if (NickName == null)
			{
				this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[1].Value = NickName;
			}
			if (Identify.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[2].Value = Identify.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
			}
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserInfoByShopID(int? ShopID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[10];
			if (ShopID.HasValue)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = ShopID.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserInfoByU_EmailForRegister(string Email)
		{
			this.Adapter.SelectCommand = this.CommandCollection[11];
			if (Email == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = Email;
			}
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserInfoByU_NickName(string NickName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[12];
			if (NickName == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = NickName;
			}
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserInfoByU_NickNameForRegister(string NickName)
		{
			this.Adapter.SelectCommand = this.CommandCollection[13];
			if (NickName == null)
			{
				this.Adapter.SelectCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				this.Adapter.SelectCommand.Parameters[0].Value = NickName;
			}
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserInfoByUserID(int UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[14];
			this.Adapter.SelectCommand.Parameters[0].Value = UserID;
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[DataObjectMethod(DataObjectMethodType.Select, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual H_UserInfo.HL_UserInfoDataTable GetUserOnlinePayInfoByUserID(int UserID)
		{
			this.Adapter.SelectCommand = this.CommandCollection[15];
			this.Adapter.SelectCommand.Parameters[0].Value = UserID;
			H_UserInfo.HL_UserInfoDataTable hL_UserInfoDataTable = new H_UserInfo.HL_UserInfoDataTable();
			this.Adapter.Fill(hL_UserInfoDataTable);
			return hL_UserInfoDataTable;
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(H_UserInfo.HL_UserInfoDataTable dataTable)
		{
			return this.Adapter.Update(dataTable);
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(H_UserInfo dataSet)
		{
			return this.Adapter.Update(dataSet, "HL_UserInfo");
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow dataRow)
		{
			return this.Adapter.Update(new DataRow[]
			{
				dataRow
			});
		}
		[HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int Update(DataRow[] dataRows)
		{
			return this.Adapter.Update(dataRows);
		}
		[DataObjectMethod(DataObjectMethodType.Update, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int AuditingUserInfo(string AuthenticationType, int UserID)
		{
			SqlCommand sqlCommand = this.CommandCollection[1];
			if (AuthenticationType == null)
			{
				sqlCommand.Parameters[0].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[0].Value = AuthenticationType;
			}
			sqlCommand.Parameters[1].Value = UserID;
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
		[DataObjectMethod(DataObjectMethodType.Insert, false), HelpKeyword("vs.data.TableAdapter"), System.Diagnostics.DebuggerNonUserCode]
		public virtual int InsertShopUserInfo(int UserID, int? ShopID, string AnthenticationType)
		{
			SqlCommand sqlCommand = this.CommandCollection[16];
			sqlCommand.Parameters[0].Value = UserID;
			if (ShopID.HasValue)
			{
				sqlCommand.Parameters[1].Value = ShopID.Value;
			}
			else
			{
				sqlCommand.Parameters[1].Value = System.DBNull.Value;
			}
			if (AnthenticationType == null)
			{
				sqlCommand.Parameters[2].Value = System.DBNull.Value;
			}
			else
			{
				sqlCommand.Parameters[2].Value = AnthenticationType;
			}
			ConnectionState state = sqlCommand.Connection.State;
			if ((sqlCommand.Connection.State & ConnectionState.Open) != ConnectionState.Open)
			{
				sqlCommand.Connection.Open();
			}
			int result;
			try
			{
				result = sqlCommand.ExecuteNonQuery();
			}
			finally
			{
				if (state == ConnectionState.Closed)
				{
					sqlCommand.Connection.Close();
				}
			}
			return result;
		}
	}
}
